Expression in a report does not work due to expression entered in label.
Cause:
The expression was entered in the label and not the control.
Solution:
In Reports Design view, retype the expression in the selected control.